using System;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.Data.Common;
using System.Collections;
using System.Collections.Generic;
using System.ComponentModel;
using System.Configuration;
using System.Xml;
using System.Xml.Serialization;
using SubSonic;
using SubSonic.Utilities;


namespace OpenProject.DataObjects{
    public partial class SPs{
        
        /// <summary>
        /// Creates an object wrapper for the IsUserInRole Procedure
        /// </summary>
        public static StoredProcedure IsUserInRole(string UserName, string RoleName)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("IsUserInRole" , DataService.GetInstance("OpenProject"));
        	
            sp.Command.AddParameter("@UserName", UserName,DbType.String);
        	    
            sp.Command.AddParameter("@RoleName", RoleName,DbType.String);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the FindUsersInRole Procedure
        /// </summary>
        public static StoredProcedure FindUsersInRole(string UserName, string RoleName)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("FindUsersInRole" , DataService.GetInstance("OpenProject"));
        	
            sp.Command.AddParameter("@UserName", UserName,DbType.String);
        	    
            sp.Command.AddParameter("@RoleName", RoleName,DbType.String);
        	    
            return sp;
        }

        
    }

    
}

